SELECT T.*,
T_USER_GROUP.CODE      AS USER_GROUP_CODE,
T_USER_GROUP.NAME      AS USER_GROUP_NAME,
T_DICTIONARY.CODE      AS BUSINESS_AREA_CODE,
T_DICTIONARY.NAME      AS BUSINESS_AREA_NAME,
T_DICTIONARY.TYPE_ID   AS BU_AREA_TYPE_ID,
T_DICTIONARY_TYPE.CODE AS BU_AREA_TYPE_CODE,
T_DICTIONARY_TYPE.NAME AS BU_AREA_TYPE_NAME
FROM C1_US_GR_BUSINESS_AREA T
LEFT JOIN C1_USER_GROUP T_USER_GROUP
ON (T_USER_GROUP.ID = T.USER_GROUP_ID)
LEFT JOIN C1_DICTIONARY T_DICTIONARY
ON (T_DICTIONARY.ID = T.BUSINESS_AREA_ID)
LEFT JOIN C1_DICTIONARY_TYPE T_DICTIONARY_TYPE
ON (T_DICTIONARY_TYPE.ID = T_DICTIONARY.TYPE_ID)
WHERE T.id          = :id